[dbo].[vSecurityRead]

SQLServer > iMIS1521GA > Views > dbo.vSecurityRead

Properties
Columns
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	3:38:38 PM Friday, January 07, 2011
Last Modified	1:49:24 PM Thursday, September 22, 2011

Columns

Name
AccessKey
UserKey

SQL Script

create view vSecurityRead as
select    AccessItem.AccessKey, UserToken.UserKey
from    AccessItem
            inner join UserToken on AccessItem.Grantee = UserToken.Grantee
where  (AccessItem.Permission & 3) > 0
group by AccessItem.AccessKey, UserToken.UserKey

GO

Uses

[dbo].[AccessItem]
[dbo].[UserToken]
dbo